SherbyNet - /page/wikibook/entry.mu

Micron Document

`:top

`!SAP SQL Anywhere`! is a proprietary `F33f`_`[relational database management system (RDBMS)`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Relational_database_management_system]`_`f product from `F33f`_`[SAP`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SAP_AG]`_`f. SQL Anywhere was known as `!Sybase SQL Anywhere`! prior to the acquisition of `F33f`_`[Sybase`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Sybase]`_`f by SAP.

>>Contents

• `F0af`_`[History`#history]`_`f

• `F0af`_`[Features`#features]`_`f

• `F0af`_`[Uses`#uses]`_`f

• `F0af`_`[Technologies`#technologies]`_`f

• `F0af`_`[History`#history]`_`f

• `F0af`_`[References`#references]`_`f

• `F0af`_`[External links`#external-links]`_`f

-─

>>History

The database company `F33f`_`[Sybase`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Sybase]`_`f obtained the SQL Anywhere technology as part of its acquisition of `F33f`_`[PowerBuilder`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=PowerBuilder]`_`f vendor PowerSoft.`:cite-ref-rdbmsingressybase20070613-1-0[`F5bf`_`[1`#cite-note-rdbmsingressybase20070613-1]`_`f]

>>Features

SQL Anywhere can be run on `F33f`_`[Windows`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Microsoft_Windows]`_`f, `F33f`_`[Windows CE`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Windows_CE]`_`f, `F33f`_`[Mac OS X`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Mac_OS_X]`_`f, and various `F33f`_`[UNIX`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=UNIX]`_`f platforms, including `F33f`_`[Linux`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Linux]`_`f, `F33f`_`[AIX`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=AIX]`_`f, `F33f`_`[HP-UX`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=HP-UX]`_`f and `F33f`_`[Solaris`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Solaris_(operating_system)]`_`f. Database files are independent of the `F33f`_`[operating system`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Operating_system]`_`f, allowing them to be copied between supported platforms. The product provides several standard interfaces (`F33f`_`[ODBC`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ODBC]`_`f, `F33f`_`[JDBC`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=JDBC]`_`f, and `F33f`_`[ADO.NET`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ADO.NET]`_`f) and a number of special interfaces such as `F33f`_`[PHP`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=PHP]`_`f and `F33f`_`[Perl`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Perl]`_`f. The engine supports `F33f`_`[stored procedures`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Stored_procedure]`_`f, user functions (using `F33f`_`[Watcom SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Watcom_SQL]`_`f, `F33f`_`[T-SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=T-SQL]`_`f, `F33f`_`[Java`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Java_(software_platform)]`_`f, or `F33f`_`[C`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=C_(programming_language)]`_`f/`F33f`_`[C++`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=C++]`_`f), `F33f`_`[triggers`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_trigger]`_`f, `F33f`_`[referential integrity`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Referential_integrity]`_`f, row-level locking, `F33f`_`[replication`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Replication_(computer_science)]`_`f, `F33f`_`[high availability`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Cluster_(computing)]`_`f, `F33f`_`[proxy tables`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Default_gateway]`_`f, and events (scheduled and system events). `F33f`_`[Strong encryption`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Strong_encryption]`_`f is supported for both database files and client-server communication.

>>Uses

SQL Anywhere is used in several contexts, including as an `F33f`_`[embedded database`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Embedded_database]`_`f, particularly as an application data store. For example, it is used in `F33f`_`[Intuit`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Intuit]`_`f `F33f`_`[QuickBooks`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=QuickBooks]`_`f,`:cite-ref-2[`F5bf`_`[2`#cite-note-2]`_`f] in network management products, and in backup products. Its ability to be used with minimal administration is a distinguishing feature in this role. It can be used as a `F33f`_`[database server`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_server]`_`f for work groups or for small or medium-sized businesses. It can also function as a `F33f`_`[mobile database`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Mobile_database]`_`f. It includes scalable `F33f`_`[data synchronization`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_synchronization]`_`f technology that provides change-based replication between separate databases, including large server-based RDBMS systems.

>>Technologies

SQL Anywhere Server is a high performing and embeddable relational database-management system (`F33f`_`[RDBMS`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Relational_database_management_system]`_`f) that scales from thousands of users in server environments down to desktop and mobile applications used in widely deployed, zero-administration environments.

`*Ultralite`*: UltraLite is a database-management system designed for small-footprint mobile devices such as PDAs and smart phones.

`*Mobilink`*: MobiLink is a highly-scalable, session-based synchronization technology for exchanging data among relational databases and other non-relational data sources.

`*QAnywhere`*: QAnywhere facilitates the development of robust and secure store-and-forward mobile messaging applications.

`*SQL Remote`*: SQL Remote technology is based on a store and forward architecture that allows occasionally connected users to synchronize data between SQL Anywhere databases using a file or message transfer mechanism.

>>History

• Initially created by `F33f`_`[Watcom`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Watcom]`_`f as `!Watcom SQL`!.

• Version 3: 1992

• Watcom acquired by `F33f`_`[Powersoft`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Powersoft]`_`f in 1993; Watcom SQL shipped with their visual programming environment `F33f`_`[PowerBuilder`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=PowerBuilder]`_`f

• Version 4: 1994 (`F33f`_`[Stored procedures`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Stored_procedure]`_`f, `F33f`_`[triggers`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_trigger]`_`f)

• PowerSoft and `F33f`_`[Sybase`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Sybase]`_`f merged in 1995: Watcom SQL was renamed `!SQL Anywhere`!.

• Version 5: 1995 (SQL Remote `F33f`_`[data replication`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_replication]`_`f; graphical administration tools)

• Version 6: 1998. Renamed `!Adaptive Server Anywhere`! (`!ASA`!). (multi-processor support, Java objects in the database)

• Version 6.0.2: 1999 (MobiLink `F33f`_`[data synchronization`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_synchronization]`_`f, UltraLite mobile database for `F33f`_`[Palm OS`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Palm_OS]`_`f and `F33f`_`[Windows CE`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Windows_CE]`_`f)

• Version 7: 2000 (dynamic `F33f`_`[cache`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_cache]`_`f, task scheduling and event handling, cross-platform administration tools)

• Version 8: 2001 (Volcano `F33f`_`[query optimizer`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Query_optimizer]`_`f, `F33f`_`[encrypted`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Encryption]`_`f data storage and transmission)

• Version 9: 2003 (`F33f`_`[Index`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Index_(database)]`_`f consultant, `F33f`_`[embedded HTTP server`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Embedded_HTTP_server]`_`f)

• Version 10: 2006 – renamed `!SQL Anywhere`! (`F33f`_`[high availability`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=High_availability]`_`f, intra-query `F33f`_`[parallelism`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Parallel_computing]`_`f, `F33f`_`[materialized views`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Materialized_view]`_`f)`:cite-ref-3[`F5bf`_`[3`#cite-note-3]`_`f]

• Version 11: 2008 (full text search, `F33f`_`[BlackBerry`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=BlackBerry]`_`f support)`:cite-ref-4[`F5bf`_`[4`#cite-note-4]`_`f]

• Version 12: 2010 released by SAP Sybase (support for `F33f`_`[spatial data`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Geodata]`_`f)`:cite-ref-5[`F5bf`_`[5`#cite-note-5]`_`f]`:cite-ref-6[`F5bf`_`[6`#cite-note-6]`_`f]

• Version 16: April 18, 2013 – (faster synchronization and improved security)`:cite-ref-7[`F5bf`_`[7`#cite-note-7]`_`f]

• Version 17: July 15, 2015; released by SAP `:cite-ref-8[`F5bf`_`[8`#cite-note-8]`_`f]

>>References

`:cite-note-rdbmsingressybase20070613-1`!1.`! `F0af`_`[↑`#cite-ref-rdbmsingressybase20070613-1-0]`_`f "RDBMS Workshop: Ingres and Sybase" (PDF) (Interview). Interviewed by Doug Jerger. Computer History Museum. 2007-06-13. Retrieved 2025-05-30.

`:cite-note-2`!2.`! `F0af`_`[↑`#cite-ref-2]`_`f "QuickBooks replaces its flat file system with SQL Anywhere from Sybase iAnywhere". Sybase.

`:cite-note-3`!3.`! `F0af`_`[↑`#cite-ref-3]`_`f "Sybase iAnywhere Announces the Release of SQL Anywhere 10". Sybase press release. August 7, 2006.

`:cite-note-4`!4.`! `F0af`_`[↑`#cite-ref-4]`_`f "Sybase iAnywhere Announces Availability of SQL Anywhere 11". Sybase press release. August 5, 2008.

`:cite-note-5`!5.`! `F0af`_`[↑`#cite-ref-5]`_`f "Sybase Advances its Mobile and Embedded Database Leadership Position with SQL Anywhere 12". Sybase press release. June 29, 2010.

`:cite-note-6`!6.`! `F0af`_`[↑`#cite-ref-6]`_`f "SAP Software Solutions | Business Applications and Technology". `*SAP`*.

`:cite-note-7`!7.`! `F0af`_`[↑`#cite-ref-7]`_`f "Archived copy" (PDF). Archived from the original (PDF) on 2014-02-11. Retrieved 2013-07-01.`B100`F9d9{{cite web}}`f`b: CS1 maint: archived copy as title (link)

`:cite-note-8`!8.`! `F0af`_`[↑`#cite-ref-8]`_`f "Announcing SQL Anywhere 17! | SAP Blogs". `*blogs.sap.com`*.

>>External links

• SQL Anywhere official product page

`c`F0af`_`[↑ Back to top`#top]`_`f`a